package com.qdu.service;

import java.util.List;

import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import org.springframework.web.multipart.MultipartFile;

import com.qdu.entity.Grade;

public interface GradeService {

	Grade getGradeById(String gradeId);
	
	Grade getGradeBySrollnoAndCpid(String srollno, int cpid);
	
	List<Grade> getGradeByStudentId(String srollno);
	
	List<Grade> getAllGrade();
	
	List<Grade> getGradeByCpid(int cpid);
	
	boolean addGrade(Grade grade, String srollno, int cpid, int pass);

	boolean modifyGrade(Grade grade, String srollno, int cpid, int pass);

	boolean deleteGradeById(String gradeId);
	
	boolean uploadGrade(MultipartFile file) throws Exception;
	
	XSSFWorkbook downloadGradeMould(int bid,int cpid);
}
